EMT Practice Test

1. Question Content...

---

Question1: A data analyst has a set of data that shows the number of gallons of oil produced each day. The company would like to know the standard deviation for the data set. The variance for the data is 36 gallons. Which of the following is the standard deviation for gallons produced?

Question2: What SQL command is used to delete an entire table from a database?

Question3: A sales team wants visibility of current sales numbers, pipeline, and team performance. The team would also like to see calculations of individuals' earned commissions and projected commissions based on sales, but they want that information to be kept confidential. Which of the following would be the BEST way to provide this visibility?

Question4: Which of the following explains why standardization of data field names is important to master data management concepts?

Question5: Given the following table:

Which of the following methods is the best way to describe the changes in the values in the table?

Question6: A marketing analytics team received customer transaction data from two different sources. The data is complete and accurate; however, the field names appear to be inconsistent. Given the following tables:

Which of the following is considered best practice if the team wants to consolidate the files and conduct further analysis?

Question7: Which of the following is an example of structured data?

Question8: A stakeholder wants to see daily sales targets organized in a dashboard by country, state, city, and ZIP Code.
Which of the following delivery considerations must a data analyst take into account when creating the dashboard?

Question9: What role in a data governance is typically responsible for day-to-day oversight of data use?

Question10: Which of the following is an example of a flat file?

Question11: A data analyst is asked to create a sales report for the second-quarter 2020 board meeting, which will include a review of the business's performance through the second quarter. The board meeting will be held on July
15, 2020, after the numbers are finalized. Which of the following report types should the data analyst create?

Question12: Which of the following is the best variable formal to store a customer's age using the least possible amount of storage data?

Question13: A military commander would like to see the health scorecards of the troops daily and filter them based on gender and rank. Considering this data is PHI, which of the following would be the best way for the commander to view the information?

Question14: Given the following graph:

Which of the following summary statements upholds integrity in data reporting?

Question15: Which of the following should an analyst do to best summarize the data on a data set?

Question16: A data set was recorded using multimedia technology. Which of the following is a necessary step on the way to interpretation?

Question17: Which of the following data types is best for representing count data?

Question18: A data scientist wants to see which products make the most money and which products attract the most customer purchasing interest in their company.
Which of the following data manipulation techniques would he use to obtain this information?

Question19: Given the following:

Which of the following is the most important thing for an analyst to do when transforming the table for a trend analysis?

Question20: A development company is constructing a new Init in its apartment complex. The complex has the following floor plans:

Using the average cost per square foot of the original floor plans. which of the following should be the price of the Rose Init?

Question21: An analyst reviews the following data:
7
3
5
2
3
7
7
10
Which of the following is the value of the mode?

Question22: An organization would like to add a secondary email field to its customer database in order toenrich the customer profiles. Which of the following data manipulation techniques should the analyst use to add this information?

Question23: Which of the following would be considered non-personally identifiable information?

Question24: A data analyst has been asked to create an ad-hoc sales report for the Chief Executive Officer (CEO).
Which of the following should be included in the report?

Question25: A database administrator needs to ensure only approved users can access specific database tables to perform financial functions. Which of the following is the best access control method for the administrator to use?

Question26: A data analyst for a media company needs to determine the most popular movie genre. Given the table below:

Which of the following must be done to the Genre column before this task can be completed?

Question27: Which of the following concepts should be applied if a data set with 40 fields needs to be pared down to 20 fields and contains similar data across multiple fields?

Question28: An analyst notices changes in sales ratios when analyzing a quarterly report. Which of the following is the analyst conducting?

Question29: During data cleansing, an analyst conducts measures of central tendency on a data set. Which of the following data is the analyst attempting to identify?

Question30: A healthcare data analyst notices that one data set in the column for BloodPressure contains several outliers that need to be replaced with meaningful values. Which of the following data manipulation techniques should the analyst use?

Question31: A table in a hospital database has a column for patient height in inches and a column for patient height in centimeters. This is an example of:

Question32: An analyst needs to join two tables of data together for analysis. All the names and cities in the first table should be joined with the corresponding ages in the second table, if applicable.

Which of the following is the correct join the analyst should complete. and how many total rows will be in one table?

Question33: After the daily ETL jobs are completed, the data in the reports does not appear complete, and a lot of data seems to be missing. Which of the following concepts should be used to assess and investigate further?

Question34: Jenny wants to study the academic performance of undergraduate sophomores and wants to determine the average grade point average at different points during an academic year.
What best describes the data set she needs?

Question35: What subset of Structured Query Language (SQL) is used to add, remove, modify, or retrieve the information stored within a relational database?

Question36: Which one of the following is a common data warehouse schema?

Question37: You should always choose the analytics tool that is most appropriate for any given situation, even if that means acquiring a new tool.

Question38: Which of the following BEST describes standard deviation?

Question39: An analyst reviews the following table:

Which of the following data types is represented in the values in the RefNo column?

Question40: A financial institution is reporting on sales performance to a company at the account level. Due to the sensitive nature of the government the does il with, some account information is not shown. Which of the following fields should be masked?

Question41: A company wants to know how its customers interact with an e-commerce website based on clicks over items.
Which of the following is the primary requirement for this report?

Question42: Which of the following is an example of a discrete variable?

Question43: Which of the following is a domain-specific language used in programming that is designed for managing data that is held in a relational data stream management system?

Question44: Which of the following types of analysis is used when comparing last week's sales to the previous week's sales?

Question45: Which of the following best describes how discrete data differs from continuous data?

Question46: Which of the following tools would be best to use to calculate the interquartile range, median, mean, and standard deviation of a column in a table that has 5.000.000 rows?

Question47: A data analyst has been asked to create a daily manufacturing report for the floor manager Which of the following metrics should be included in the report?

Question48: Which of the following is an example of a discrete data type?

Question49: An analyst is required to run a text analysis of data that is found in articles from a digital news outlet. Which of the following would be the BEST technique for the analyst to apply to acquire the data?

Question50: You would like to measure how well an organization is achieving its goals.
What type of analysis should you perform?

Question51: A data analyst is creating a report that will provide information about various regions, products, and time periods. Which of the following formats would be themost efficient way to deliver this report?

Question52: Angela is aggregating data from CRM system with data from an employee system.
While performing an initial quality check, she realizes that her employee ID is not associated with her identifier in the CRM system.
What kind of issues is Angela facing?
Choose the best answer.

Question53: Which of the following data types must be used when working with variables that require classification into two or more groups before analysis?

Question54: Given the following grocery store orders:

If a query is made to the table with the following logic:
Order_Total > 132 OR (Order Total >= 25 AND Order_Total < 74)
Which of the following is the number of orders that will be returned by the query?

Question55: Which of the following report types is most appropriate for a high-level, year-end report requested by a Chief Executive Officer?

Question56: Given the following data set:

Which of the following is the best reason for cleansing the data?

Question57: While reviewing survey data, an analyst notices respondents entered "Jan," "January," and "01" as responses for the month of January. Which of the following steps should be taken to ensure data consistency?

Question58: A data analyst is developing a data dictionary that aligns with a company's data management processes and policies.
Which of the following best describes what should be included in the data dictionary?

Question59: An analyst has received the requirements for an internal user dashboard. The analyst confirms the data sources and then creates a wireframe. Which of the following is the NEXT step the analyst should take in the dashboard creation process?

Question60: A sales manager wants quarterly sales reports broken down by unit and week. Which of the following data output lists includes the most necessary information?

Question61: Which of the following is the best description of the term "data governance"?

Question62: A research analyst wants to determine whether the data being analyzed is connected to other datapoints.
Which of the following is the BEST type of analysis to conduct?

Question63: A research analyst collects ten data points from 1.000 specimens. The analyst will not need any additional data to complete the analysis and will not need to retrieve information by specifier. Which of the following is the best data structure for the analyst to use?

Question64: Which of the following is the best reason to use database views instead of tables?

Question65: Which of the following is an example of a at flat file?

Question66: Given the table below:

Which of the following variable types BEST describes the "Year" column?

Question67: Which of the following occurs if a 90% confidence interval increases to 95%?

Question68: Which of the following data types would a telephone number formatted as XXX-XXX-XXXX be considered?

Question69: Which of the following describes the method of sampling in which elements of data are selected randomly from each of the small subgroups within a population?

Question70: A survey asks participants to rate a company on a scale of one to ten. Which of the following best describes the rating variable?

Question71: The total values in this month's revenue report are twice as much as last month's. Which of the following most likely occurred during the ETL process?

Question72: A data analyst is setting up a data dashboard to monitor several ETL data streams to ensure that data is complete for later analysis. Which of the following audiences should the analyst target for this dashboard?

Question73: A data analyst reviews the following data set:

Which of the following is the range value?

Question74: The process of performing initial investigations on data to spot outliers, discover patterns, and test assumptions with statistical insight and graphical visualization is called:

Question75: A data analyst has received a data set that contains actual and projected sales for the fourth quarter of 2019.
Which of the following statistical methods should the analyst use to find the measure of dispersion?

Question76: A data analyst received the information in the table below from a recently completed marketing campaign:

Which of the following is the total order conversion rate?

Question77: A data analyst needs to present the results of an online marketing campaign to the marketing manager. The manager wants to see the most important KPIs and measure the return on marketing investment. Which of the following should the data analyst use to BEST communicate this information to the manager?

Question78: A data analyst is creating a dashboard and trying to identify the type of information that should be included.
Which of the following should the analyst consider first?

Question79: An analyst is creating a resource to improve users' experience when they select specific records based on particular dates. Which of the following should the analyst use to create a resource that best meets user needs?

Question80: A data analyst has a set with more than 40.000 rows in the sample schema below:

The analyst would like to create one column that contains the customers' birth dates. Which of the following data quality dimensions would BEST explain the reason for compilation?

Question81: Q3 2020 has just ended, and now a data analyst needs to create an ad-hoc sales report that demonstrates how well the Q3 2020 promotion went versus last year's Q3 promotion.
Which of the following date parameters should the analyst use?

Question82: The duration of a phone call in milliseconds is an example of:

Question83: A sales director has requested a report for individual team members within the division be developed. The director would like the report to be shared with all team members, but individual team members should not be identifiable within the report Which of the following access requirements would support the director's needs?

Question84: An analyst is preparing a report that contains weather data. The temperatures are shown in Fahrenheit. but they must be reported in Celsius. Which of the following should the analyst do to fix this issue?

Question85: A data analyst needs to create a master file that includes customer information from the tables below:

Given the three tables above, the analyst wants to filter down the information prior to joining it together. In which of the following orders should this data manipulation bo approached for the most efficient result?

Question86: Which of the following is a best practice when updating a legacy data source?

Question87: The number of phone calls that the call center receives in a day is an example of:

Question88: An analyst is designing a dashboard to determine which site has the highest percentage of new customers. The analyst must choose an appropriate chart to include in the dashboard. The following data is available:

Which of the following types of charts should be considered to BEST display the data?

Question89: You are working with a dataset and want to change the names of categories that you used fordifferent types of books.
What term best describes this action?

Question90: Which one of the following in NOT a common data integration tool?

Question91: Which of the following is a control measure for preventing a data breach?

Question92: Given the image below:

The data should be cleaned because of the presence of:

Question93: Which of the following statistical methods requires two or more categorical variables?

Question94: Which of the following variable name formats would be problematic if used in the majority of data software programs?

Question95: Given the diagram below:

Which of the following steps is missing?

Question96: Which of the following should be accomplished NEXT after understanding a business requirement for a data analysis report?

Question97: Which of the following data governance concepts fits into the security requirements category?

Question98: An analyst is working on a project for a director. During this process. the analyst pulled the data. created summarized tables and graphs with descriptions, created a report summary, and inserted all items into a report. After writing the report, which of the following would be the most appropriate next step?

Question99: Each month an analyst needs to execute a data pull for the two prior months. Which of the following is the most efficient function for the analyst to use?

Question100: A sales manager requested a report that contains the first name, last name, and phone number of all the company's customers and employees. The data engineer needs to return all the records from several tables, even duplicates. Which of the following is the best way to join the two tables?

Question101: A data analyst is working with a team to create a dashboard for a client who requires on-demand access.
Which of the following is the best delivery method to support the clients' requirement?

Question102: Which of the following is the best approach to use to gain a general understanding of a data set?

Question103: Which of the following is a non-parametric test?

Question104: Which of the following activities occurs during the ETL process?

Question105: Given the diagram below:

Which of the following types of sampling is depicted in the image?

Question106: A data analyst needs to observe the relationship between two numeric variables and identify the clustering pattern as well as the outliers. Which of the following visualizations should the analyst use?

Question107: Which of the following query optimization techniques involves examining only the data that is needed for a particular task?

Question108: Which of the following is the most appropriate to consider when creating a schema of a central group broken into detailed subcategories?

Question109: Alex wants to use data from his corporate sale, CRM, and shipping systems to try and predict future sales.
Which of the following systems is the most appropriate?
Choose the best answer.

Question110: A data analyst received a large amount of third-party data that needs to be joined with in-house data files.
After the data is joined, the analyst notices three columns all contain dates. Which of the following should the analyst do to maintain data consistency?

Question111: An analyst wants to combine two data sets into a single spreadsheet. Column names from the first spreadsheet are listed in rows in the second spreadsheet. Which of the following is the first step the analyst should take to combine the data sets?

Question112: Given the image below:

Which of the following file formats is depicted?

Question113: A data analyst is working for a shipping company and calculating the volume of boxes according to the following formula: volume = height × width × depth. Which of the following variable types describes volume?

Question114: Which one the following is not considered an aggregate function?

Question115: Which of the following best describes a business analytics tool with interactive visualization and business capabilities and an interface that is simple enough for end users to create their own reports and dashboards?

Question116: Which of the following is a KPI metric for tracking sales performance?

Question117: An analysts building a monthly report for production and wants to ensure the audience is aware of its once-a- month cadence. Which of the following is the MOST important to convey that information?

Question118: A sales analyst needs to report how the sales team is performing to target. Which of the following files will be important in determining 2019 performance attainment?

Question119: Which of the following is an object associated with a table that sorts and stores table row data in a key-value pair?

Question120: A database administrator needs to increase performance on a large dimension table. Which of the following is the best way to accomplish this task?

Question121: Which of the following is a difference between a primary key and a unique key?

Question122: Daniel is using the structured Query language to work with data stored in relational database.
He would like to add several new rows to a database table.
What command should he use?

Question123: A user receives a large custom report to track company sales across various date ranges. The user then completes a series of manual calculations for each date range. Which of the following should an analyst suggest so the user has a dynamic, seamless experience?

Question124: A data analyst has been asked to organize the table below in the following ways:
By sales from high to low -
By state in alphabetic order -

Which of the following functions will allow the data analyst to organize the table in this manner?

Question125: Given the data below:

In which of the following file formats is the data presented?

Question126: Given the table below:

Which of the following boxes indicates that a Type Il error has occurred?

Question127: A data analyst must separate the column shown below into multiple columns for each component of the name:

Which of the following data manipulation techniques should the analyst perform?

Question128: An analyst has been tracking company intranet usage and has been asked to create a chat to show the most- used/most-clicked portions of a homepage that contains more than 30 links. Which of the following visualizations would BEST illustrate this information?

Question129: Which of the following is used for calculations and pivot tables?

Question130: A data analyst is attempting to understand how ice cream consumption is affected by different attributes. such as cost, temperature. and income level. Which of the following regression analyses should the data analyst perform to understand this relationship?

Question131: An analyst modified a data set that had a number of issues. Given the original and modified versions:

Which of the following data manipulation techniques did the analyst use?

Question132: A Chief Executive Officer (CEO) is requesting more up-to-date sales data for improved visibility prior to month-end. An analyst must determine the frequency of a sales report that was previously distributed on an as- needed basis. Which of the following would be the most appropriate frequency for this report?

Question133: A data analyst wants to create "Income Categories" that would be calculated based on the existing variable
"Income". The "Income Categories" would be as follows:
Income category 1: less than $1.
Income category 2: more than $1 and less than $20,000.
Income category 3: more than $20,001 and less than $40,000.
Income category 4: more than $40,001.
Which of the following data manipulation techniques should the data analyst use to create "Income Categories"?

Question134: A recurring event is being stored in two databases that are housed in different geographical locations. A data analyst notices the event is being logged three hours earlier in one database than in the other database. Which of the following is the MOST likely cause of the issue?

Question135: Which of the following statements would be used to append two tables that have the same number of columns?

Question136: Given the following data sample:

Which of the following best describes the data quality issue?

Question137: A data analyst was asked to create a chart that shows the relationship between study hours and exam scores for each student using the data sets in the table below:

Which of the following charts would BEST represent the relationship between the variables?

Question138: A business intelligence team wants to create a new dashboard in order to solve a problem statement. Which of the following is the correct order of steps the team should take?

Question139: A data analyst is developing a dashboard to track and monitor metrics. Which of the following best practices should be taken into during the FIRST pment process?

Question140: Amanda needs to create a dashboard that will draw information from many other data sources and present it to business leaders.
Which one of the following tools is least likely to meet her needs?

Question141: An analyst runs a report on a daily basis, and the number of datapoints must be validated before the data can be analyzed. The number of datapoints increases each day by approximately 20% of the total number from the day before. On a given day, the number of datapoints was 8,798. Which of the following should be the total number of datapoints on the next day?

Question142: A data analyst needs to perform a full outer join of a customer's orders using the tables below:

Which of the following is the mean of the order quantity?

Question143: Which of the following data governance concepts fits into the security requirements category?

Question144: An analyst is building a new dashboard for a user. After an initial conversation with the user. the analyst created a mock-up of the dashboard. Which of the following best explains why the analyst created the mock- up?

Question145: Which of the following data sampling methods involves dividing a population into subgroups by similar characteristics?

Question146: A data analyst has been asked to derive a new variable labeled "Promotion_flag" based on the total quantity sold by each salesperson. Given the table below:

Which of the following functions would the analyst consider appropriate to flag "Yes" for every salesperson who has a number above 1,000,000 in the Quantity_sold column?

Question147: You are working with a professional statistician to perform an analysis and would like to use a statistics package.
Which one of the following would be the most appropriate?

Question148: A junior web developer is developing a new application where users can upload short videos. The first task is to create a homepage that shows the headline "Upload Your Short Videos" and a clickable button that says
"upload now".
Which of the following HTML commands would help the developer to complete the task successfully?

Question149: Taylor wants to investigate how manufacturing, marketing, and sales expenditures impact overall profitability for her company.
Which of the following systems is the most appropriate?

Question150: An analyst is updating a customer contacts database with information obtained from a survey of new customers. Which of the following data manipulation techniques should the analyst use?

Question151: Which of the following is most likely to be used as a data-mining ETL tool?

Question152: A data analyst needs to create a dashboard using the company's yearly revenue data sets. Which of the following would be the best way to plot the information to show the top-performing region?

Question153: A data analyst needs to write a SOL query measuring last month's website visits and distribute a summary report to the marketing team. Which of the following is the analyst creating?